CD Access - Your Desktop Software Store (Macintosh)

home *** CD-ROM | disk | FTP | other *** search

/ CD Access - Your Desktop…oftware Store (Macintosh) / CD Access - Your Desktop Software Store.iso / Product Demos / BIZ Basics™ Pro 2.1 / Inv_Hist.FM (.txt) < prev next >

Wrap

FileMaker Pro Database | 1994-01-03 | 154KB | 2,517 lines

January@ Widgeta Updatedb Richard PrintingT CURRENT INVENTORY HBAM2001MAY84 Inv_Hist.FM:* T-099 T-100 T-101 Carton Coated Company Corrugated Envelope Jiffy Kraft Large M-large Plastic Powered Shipping Solar T-shirt Tough Widget X-large Browne Customer Dennis Julie Manager Manager Sales Smith E1003 E1004 92159 92160 92161 92186 93118 93119 93120 93122 93128 93129 93159 93164 P-1047 P-1048 P-1049 P-1051 P-1904 P-1999 August February January March September Coated Large Plastic Solar Widget Widget Bought Returned Updated Updated Company Direct Marketing S1001 S1002 S1003 S1004 S1005 S1006 S1007 S1008 S1009 S1010 S1011 S1012 S1095 Assorted Colors Metallic White Large Medium Sizes X-large Cv103 Cv104 Cv105 Cv106 Cv107 Cv110 Cv111 Cv112 Department Discount Distributors Level Martin Richard Richard Snider Stores Supplier Technologies Warehouse Cv104 Cv105 Cv106 Cv107 Cv111 Department Discount Distributors Level Lodging Martin Premiere Printing Printing Resort Richard Shipping Snider Stores Supplier Supply Technologies Warehouse Pro 2.0F! Pro 2.0 - 2.1I 1/3/94 CALCULATED VALUE CI QTY SOLD COLOR COMPONENT LIST? COMPONENT NAME COMPONENT NUMBER COMPONENT PRICE COMPONENT QTY CALCULATED VALUE CI QTY SOLD COLOR COMPONENT LIST? COMPONENT NAME COMPONENT NUMBER COMPONENT PRICE COMPONENT QTY CALCULATED VALUE CI QTY SOLD COLOR COMPONENT LIST? COMPONENT NAME COMPONENT NUMBER COMPONENT PRICE COMPONENT QTY CURRENT INVENTORY CUST...VEND LOOKUP CODE CUST...VEND NAME DATE REC'D EMP NAME TITLE CALC GROSS PROFIT GROSS PROFIT SUM INVENTORY ACTION INVENTORY UPDATED? INVOICE NUMBER ITEM COST ITEM NAME ITEM NUMBER ITEMS SOLD VALUE FROM INVOICES MAX ORDER DATE MIN ORDER DATE MONTH NAME MONTH NUMBER ON HAND ON HAND SUM ORDER DATE PRICE EXTENDED PRICE EXTENDED SUM PRICE TYPE CALC * QTY REC'D QTY SOLD SALES ORDER NUMBER SOLD BY SUM TOTAL QTY SOLD SUMMARY OF QTY REC'D SUMMARY OF QTY SOLD TOTAL ITEMS SUM TOTAL QTY SOLD UPDATE DATE VALUE SUMMARY WHICH QUARTER? YOUR COMPANY NAME YOUR COMPANY NUMBER Item NumberB Qty SoldB Summary of Qty SoldB A Item NameB A Item CostB Order DateB Update DateB Emp Name Title CalcB Sold ByB Invoice NumberB On HandB SoldB Current InventoryB On Hand - Sold On Hand SumB CI qty soldB On Hand - Qty Sold Total Items SumB Value SummaryB Month NameB monthName(Order Date) Month NumberB Month(Order Date) Which Quarter?B if(Month Number 1 AND Month Number 3, 1, if(Month Number 4 AND Month Number 6,2, if(Month Number 7 AND Month Number 9,3,4))) Min Order DateB Max Order DateB Component List?B Products.FM Component NumberB Products.FM Component NameB Products.FM Component QtyB Products.FM Component PriceB Products.FM Total Qty SoldB Azif((extend(Qty Sold) = "") OR (extend(Qty Sold) = 0), extend(Qty Rec'd) * Component Qty, extend(Qty Sold) * Component Qty) Sum Total Qty SoldB _N^Nu "A Qty Rec'dB Inventory ActionB Bought Returned Date Rec'dB Inventory Updated?B Updated Price ExtendedB Qty Sold * Price Type Calc Price Extended SumB Gross ProfitB A!Price Extended - Calculated Value Gross Profit SumB Price Type Calc Items Sold Value From InvoicesB Calculated ValueB ALif(Inventory Action = "Bought", Qty Rec'd * Item Cost, Qty Sold * Item Cost) Bought YearB Year(Order Date) Your Company NameB Your Company NumberB Summary of Qty Rec'dB Sales Order NumberB ColorB SizeB Cust...Vend Lookup CodeB Cust...Vend NameB TABULATE Items Sold Report FIND DATE RANGE Items Sold (By Month) Items Sold (By Quarter) Items Sold (By Sales Person) FIND DATE RANGE & ITEM NUMBER A"FIND DATE(s), ITEM(s), SALESPERSON REPORTS Items Purchased (By Month) Items Purchased (By Quarter) Items Sold Report By Customer TABULATEB Item Number Qty Sold E Item Name E Item Cost Order Date Update Date Emp Name Title Calc Sold By Invoice Number Component List? E Qty Rec'd Date Rec'd Extended Sell Price ea Items Sold Value From Invoices Reports Your Co Name Your Co Number Sales Order Number Color Cust/Vend Lookup Code Cust...Vend Name Items Sold ReportB Items Sold Report As of // at :: Reports Item# E Item Name Qty Sold Item Cost Ea. Total Cost Total Cost Total Qty Sold E Sales Amt Gross Profit Totals for ALL Companies Total Cost Total Qty Sold FIND DATE RANGEB Manager 92186@ January@ Widgeta Updatedb Richard PrintingT CURRENT INVENTORY Order Date(s) EkEnter the Order Date (i.e. 4/1/93) or the date range (i.e. 4/1/93...6/1/93) that you would like a report on EkEnter the Order Date (i.e. 4/1/93) or the date range (i.e. 4/1/93...6/1/93) that you would like a report on Order Date(s) Find Date Range Reports Your Company Number Your Company Number Items Sold (By Month) Items Sold By Month As of // at :: Item# E Item Name Qty Sold Item Cost Ea. Total Cost Total Cost Total Qty Sold Total Cost Total Qty Sold E Sales Amt Gross Profit Totals for ALL Months Page ## Reports Total Cost Total Qty Sold Items Sold (By Quarter)B Items Sold By Quarter As of // at :: Page ## Item# E Item Name Qty Sold Item Cost Ea. Total Cost Total Cost Total Qty Sold Total Cost Total Qty Sold E Sales Amt Gross Profit Total Cost Total Qty Sold Totals for ALL Companies Reports Total Cost Total Qty Sold Items Sold (By Sales Person)B Itemized Sales By Sales Person As of // at :: Page ## Sold By: Totals for Total Sales Total Qty Sold Item# E Item Name Qty Sold Item Cost Ea. Total Cost Total Cost Total Qty Sold E Sales Amt Gross Profit Reports Total Cost Total Qty Sold Total Cost Total Qty Sold Totals For ALL Companies FIND DATE RANGE & ITEM NUMBERB Order Date(s) Order Date(s) Find Date Range & Item Number Item Number Item Number Reports Your Company Number Your Company Number 1. Enter the Order Date (i.e. 4/1/93) or the date range (i.e. 4/1/93...6/1/93) that you would like a report on. 2. If you wish to limit your FIND by any existing Item Number or Your Company # you may als B7o enter the applicable data on this screen (optional). A"FIND DATE(s), ITEM(s), SALESPERSONB Order Date(s) 1. Enter the Order Date (i.e. 4/1/93) or the date range (i.e. 4/1/93...6/1/93) that you would like a report on. 2. If you wish to limit your FIND by any existing Item Number, Salesperson or Your Company BD# you may also enter the applicable data on this screen (optional). Order Date(s) Find Dates, Items & Salesperson Item Number Item Number Salesperson Number Salesperson Number Reports Your Company Number Your Company Number REPORTSB Inventory History Reports E Item Sold Report By Month & Item E Item Sold Report By Month & Item E"Item Sold Report By Quarter & Item E#Item Sold Report By Quarter & Item E&Item Sold Report By Salesperson & Item E'Item Sold Report By Salesperson & Item Item Sold Report By Month Item Sold Report By Month Item Sold Report By Quarter Item Sold Report By Quarter FUTURE FUTURE FUTURE FUTURE E#Item Purchd. Report By Month & Item E#Item Purchd. Report By Month & Item E%Item Purchd. Report By Quarter & Item E%Item Purchd. Report By Quarter & Item BIZ Basics Pro 2.1v1 Item Sold Report By Customer Item Sold Report By Customer Items Purchased (By Month)B Items Purch. By Month As of // at :: Item# Vendor Description E Qty Rec Item Cost Ea. Total Cost Total Cost Total Qty Rec Total Cost Total Qty Rec Totals for ALL Months Page ## Reports Total Cost Total Qty Rec Items Purchased (By Quarter)B Items Purch. By Quarter As of // at :: Page ## Item# Vendor Description E Qty Rec Item Cost Ea. Total Cost Total Cost Total Qty Rec Total Cost Total Qty Rec Total Cost Total Qty Rec Totals for ALL Companies Reports Total Cost Total Qty Rec Intentionally Left Blank Items Sold Report By CustomerB Items Sold By Customer As of // at :: Reports Item# E Item Name Qty Sold Item Cost Ea. Total Cost Total Cost Total Qty Sold E Sales Amt Gross Profit Totals for ALL Companies Total Cost Total Qty Sold 026D,Kraft 9 x 12 shipping envelope (10 per Case)E 8.90F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92e Updatedh -44.5l 44.5m 1992n ABC Direct Marketingo S1095t CV110u A-1 Shipping Supply D(Jiffy #3 shipping envelope (25 per Case)E 16.90F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92e Updatedh -169l 1992n ABC Direct Marketingo CV110u A-1 Shipping Supply 032D110 x 10 x 3 Corrugated shipping box (20 per Case)E 21.63F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92e Updatedh -129.78l 129.78m 1992n ABC Direct Marketingo CV110u A-1 Shipping Supply T-099D M-Large Logo T (ea)E 4.75F 9/20/92G 11/19/93J P-1048U September Boughtd 9/27/92e Updatedh 1992n XYZ Companyo CV112u Premiere Printing T-100D Large Logo T (ea)E 4.75F 9/20/92G 11/19/93J P-1048U SeptemberV Boughtd 9/27/92e Updatedh -285l 1992n XYZ Companyo CV112u Premiere Printing T-101D X-Large Logo T (ea)E 4.75F 9/20/92G 11/19/93J P-1048U SeptemberV Boughtd 9/27/92e Updatedh -232.75l 232.75m 1992n XYZ Companyo CV112u Premiere Printing T-099D M-Large Logo T (ea)E 8/1/92G 11/19/93J P-1049U AugustV Boughtd 9/20/92e Updatedh -950l 1992n ABC Direct Marketingo CV112u Premiere Printing T-101D X-Large Logo T (ea)E 4.75F 8/1/92G 11/19/93J P-1049U AugustV Boughtd 9/20/92e Updatedh -950l 1992n ABC Direct Marketingo CV112u Premiere Printing TOUGH PAK KIT (10 per Box)E 10.49F 1/6/93G 11/19/93J P-1904U JanuaryV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Boughtd 1/17/93e Updatedh -20.98l 20.98m 1993n ABC Direct Marketingo CV111u Discount Supplier Warehouse SOLAR POWERED WIDGET (ea)E 3.19F 1/6/93G 11/19/93J P-1904U JanuaryV Boughtd 1/17/93e Updatedh -9.57l 9.57m 1993n ABC Direct Marketingo CV111u Discount Supplier Warehouse 026D,Kraft 9 x 12 shipping envelope (10 per Case)E 8.90F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92 Updatedh -44.5l 44.5m 1992n ABC Direct Marketingo CV110u A-1 Shipping Supply 030D(Jiffy #3 shipping envelope (25 per Case)E 16.90F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92e Updatedh -169l 1992n ABC Direct Marketingo CV110u A-1 Shipping Supply 032D110 x 10 x 3 Corrugated shipping box (20 per Case)E 21.63F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92e Updatedh -129.78l 129.78m 1992n ABC Direct Marketingo CV110 A-1 Shipping Supply 038D160 x18 x 12 Corrugated shipping box (20 per Case)E 25.56F 9/6/92G 11/19/93J P-1047U SeptemberV Boughtd 9/10/92e Updatedh -76.68l 76.68m 1992n ABC Direct Marketingo CV110u A-1 Shipping Supply 026D,Kraft 9 x 12 shipping envelope (10 per Case)E 8.90F 9/21/92G 11/19/93J P-1051U SeptemberV Boughtd 7/21/92e Updatedh -26.7l 26.7m 1992n XYZ Companyo CV110u A-1 Shipping Supply D-Kraft 6 x 9 shipping envelope (20 per Carton)E 4.25F 9/21/92G 11/19/93J P-1051U SeptemberV Boughtd 7/21/92e Updatedh -12.75l 12.75m 1992n XYZ Companyo CV110u A-1 Shipping Supply 028D(Jiffy #1 shipping envelope (25 per Case)E 4.20F 9/21/92G 11/19/93J P-1051U SeptemberV Boughtd 7/21/92e Updatedh 1992n XYZ Companyo CV110u A-1 Shipping Supply T-099D M-Large Logo T (ea)E 4.75F 9/20/92G 11/19/93J P-1048U SeptemberV Bought 9/27/92e Updatedh 1992n XYZ Companyo CV112u Premiere Printing T-100D Large Logo T (ea)E 4.75F 9/20/92G 11/19/93J P-1048U SeptemberV Boughtd 9/27/92e Updatedh -285l 1992n XYZ Companyo CV112u Premiere Printing T-101D X-Large Logo T (ea)E 4.75F 9/20/92G 11/19/93J P-1048U SeptemberV Boughtd 9/27/92e Updatedh -232.75l 232.75m 1992n XYZ Companyo CV112u Premiere Printing T-099D M-Large Logo T (ea)E 4.75F 8/1/92G 11/19/93 P-1049U AugustV Boughtd 9/20/92e Updatedh -1543.75l 1543.75m 1992n ABC Direct Marketingo CV112u Premiere Printing T-100D Large Logo T (ea)E 4.75F 8/1/92G 11/19/93J P-1049U AugustV Boughtd 9/20/92e Updatedh -1995l 1995m 1992n ABC Direct Marketingo CV112u Premiere Printing TOUGH PAK KIT (10 per Box)E 10.49F 1/6/93G 11/19/93J P-1999U JanuaryV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Boughtd 1/17/93e Updatedh -52.45l 52.45m 1993n ABC Direct Marketingo CV107u Snider Distributors SOLAR POWERED WIDGET (ea)E 3.19F 1/6/93G 11/19/93J P-1999U JanuaryV Boughtd 1/17/93e Updatedh -12.76l 12.76m 1993n ABC Direct Marketingo CV107u Snider Distributors Plastic Coated WidgetE .0405F 1/6/93G 11/19/93J P-1904U JanuaryV Boughtd 1/17/93e Updatedh -.405k .405l .405m ABC Direct Marketingo Discount Supplier Warehouseu CV111 Large Box 1E 1.5495F 1/6/93G 11/19/93J P-1904U JanuaryV Boughtd 1/17/93e Updatedh -3.099k 3.099l 3.099m 1993n ABC Direct Marketingo Discount Supplier Warehouseu CV111 Solar WidgetE 1.2975F 1/6/93G 11/19/93J P-1904U JanuaryV Boughtd 1/17/93e Updatedh -5.19k 5.19l 5.19m 1993n ABC Direct Marketingo Discount Supplier Warehouseu CV111 Plastic Coated WidgetE .0405F 1/6/93 11/19/93J P-1999U JanuaryV Boughtd 1/17/93e Updatedh -1.0125k 1.0125l 1.0125m 1993n ABC Direct Marketingo Snider Distributorsu CV107 Large Box 1E 1.5495F 1/6/93G 11/19/93J P-1999U JanuaryV Boughtd 1/17/93e Updatedh -7.7475k 7.7475l 7.7475m 1993n ABC Direct Marketingo Snider Distributorsu CV107 Solar WidgetE 1.2975F 1/6/93G 11/19/93J P-1999U JanuaryV Boughtd 1/17/93e Updatedh -12.975k 12.975l 12.975m 1993n ABC Direct Marketing Snider Distributorsu CV107 T-100B XYZ Company T-shirt - LE 4.75F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Solde Updatedf 747.5h 14.95k 747.5l 237.5m 1993n ABC Direct Marketingo S1001r Whites Larget CV104u Level Technologies, Inc. T-099B XYZ Company T-shirt - ME 4.75F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Solde Updatedf 224.25h 14.95k 224.25l 71.25m ABC Direct Marketingo S1001r Assorted Colorss All Sizest CV104u Level Technologies, Inc. 2D Tough PakE 4.347F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 71.98h 63.286j 35.99k 71.98l 8.694m 1993n ABC Direct Marketingo S1001r Whites Mediumt CV104u Level Technologies, Inc. Solar WidgetE 3.19F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Solde Updatedf 9.05j 15.95m 1993n ABC Direct Marketingo S1001r Metallics Mediumt CV104u Level Technologies, Inc. T-099B XYZ Company T-shirt - ME 4.75F 6/15/92G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92160Q JuneV Solde Updatedf 1992n XYZ Companyo S1003r Assorted Colorss All Sizest CV105 May Department Stores T-100B XYZ Company T-shirt - LE 4.75F 6/15/92G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92160Q JuneV Solde Updatedf 237.5h 118.75j 237.5l 118.75m 1992n XYZ Companyo S1003r Whites Larget CV105u May Department Stores T-101B XYZ Company T-shirt - XLE 4.75F 6/15/92G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92160Q JuneV Solde Updatedf 332.5h 166.25j 332.5l 166.25m 1992n XYZ Companyo S1003r Whites X-Larget CV105u May Department Stores T-100B XYZ Company T-shirt - LE 4.75F 5/1/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92161Q Solde Updatedf 224.25h 14.95k 224.25l 71.25m 1993n ABC Direct Marketingo S1004r Whites Larget CV104u Level Technologies, Inc. 1D Tough PakE 4.347F 5/1/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92161Q Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 35.99h 31.643j 35.99k 35.99l 4.347m 1993n ABC Direct Marketingo S1004r Whites Mediumt CV104u Level Technologies, Inc. T-100B XYZ Company T-shirt - LE 4.75F 9/28/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92186Q -6U SeptemberV Solde Updatedf -28.5j 28.5m 1993n XYZ Companyo S1002r Whites Larget CV105u May Department Stores 2D Tough Pak 4.347F 9/28/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92186Q -2U SeptemberV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf -8.694j 8.694m 1993n XYZ Companyo S1002r Whites Mediumt CV105u May Department Stores Solar WidgetE 3.19F 9/28/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92186Q -6U SeptemberV Solde Updatedf 64.86j 19.14m 1993n XYZ Companyo S1002r Metallics Mediumt CV105u May Department Stores T-100B XYZ Company T-shirt - LE 4.75F 6/11/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Solde Updatedf 47.5h 23.75j 47.5l 23.75m 1993n XYZ Companyo S1006r Whites Larget CV107u Snider Distributors Solar WidgetE 3.19F 6/11/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Solde Updatedf 20.25h 10.68j 20.25l 9.57m 1993n XYZ Companyo S1006r Metallics Mediumt CV107u Snider Distributors 1D Tough PakE 4.347F 6/11/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 11.5h 7.153j 11.5k 11.5l 4.347m 1993n XYZ Companyo S1006r Whites Mediumt CV107u Snider Distributors T-099B XYZ Company T-shirt - ME 6/11/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Solde Updatedf 28.5h 14.25j 28.5l 14.25m 1993n XYZ Companyo S1006r Assorted Colorss All Sizest CV107u Snider Distributors T-099B XYZ Company T-shirt - ME 4.75F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93120Q JanuaryV Solde Updatedf 142.5h 71.25j 142.5l 71.25m 1993n ABC Direct Marketingo S1007r Assorted Colorss All Sizest CV107 Snider Distributors 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93120U JanuaryV Solde Updatedf 1993n ABC Direct Marketingo S1007t CV107u Snider Distributors 1D Tough PakE 4.347F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 12.5h 8.153j 12.5k 12.5l 4.347m ABC Direct Marketingo S1008r Whites Mediumt CV107u Snider Distributors Solar WidgetE 3.19F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Solde Updatedf 74.25h 39.16j 6.75k 74.25l 35.09m 1993n ABC Direct Marketingo S1008r Metallics Mediumt CV107u Snider Distributors T-099B XYZ Company T-shirt - ME 4.75F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Solde Updatedf 4.75m 1993n ABC Direct Marketingo S1008r Assorted Colorss All Sizest CV107u Snider Distributors T-100B XYZ Company T-shirt - LE 4.75F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Solde Updatedf 40.5h 26.25j 13.5k 40.5l 14.25m 1993n ABC Direct Marketingo S1008r Whites Larget CV107u Snider Distributors T-100B XYZ Company T-shirt - LE 4.75F 1/17/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93128Q JanuaryV Solde Updatedf 97.5j 14.5k 47.5m 1993n XYZ Companyo S1009r Whites Larget CV106u Richard Martin 2D Tough PakE 4.347F 1/17/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93128Q JanuaryV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 71.98h 63.286j 35.99k 71.98l 8.694m 1993n XYZ Companyo S1009r Whites Mediumt CV106 Richard Martin 4D Tough PakE 4.347F 1/16/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93129Q JanuaryV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 82.612j 17.388m 1993n XYZ Companyo S1010r Whites Mediumt CV107u Snider Distributors Solar WidgetE 3.19F 1/16/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93129Q JanuaryV Solde Updatedf 6.75h 3.56j 6.75k 6.75l 3.19m 1993n XYZ Companyo S1010r Metallics Mediumt CV107u Snider Distributors 3D Tough PakE 4.347F 2/21/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93159Q FebruaryV Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Solde Updatedf 41.94h 28.899j 13.98k 41.94l 13.041m 1993n XYZ Companyo S1011r Whites Mediumt CV107 Snider Distributors Solar WidgetE 3.19F 2/21/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93159Q FebruaryV Solde Updatedf 14.24j 6.75k 12.76m 1993n XYZ Companyo S1011r Metallics Mediumt CV107u Snider Distributors T-100B XYZ Company T-shirt - LE 4.75F 3/26/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93164Q MarchV Solde Updatedf 1993n XYZ Companyo S1012r Whites Larget CV105 May Department Stores T-099B XYZ Company T-shirt - ME 4.75F 3/26/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93164Q MarchV Solde Updatedf 142.5h 71.25j 142.5l 71.25m 1993n XYZ Companyo S1012r Assorted Colorss All Sizest CV105u May Department Stores Plastic Coated WidgetE .0405F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Solde Updatedf -.405l .405m 1993n ABC Direct Marketingo S1001 Whites Mediumt Level Technologies, Inc.u CV104 Large Box 1E 1.5495F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Solde Updatedf -3.099l 3.099m 1993n ABC Direct Marketingo S1001r Whites Mediumt Level Technologies, Inc.u CV104 Solar WidgetE 1.2975F 7/6/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92159Q JulyV Solde Updatedf -5.19l 5.19m 1993n ABC Direct Marketingo S1001r Whites Medium Level Technologies, Inc.u CV104 Plastic Coated WidgetE .0405F 5/1/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92161Q Solde Updatedf -.2025l .2025m 1993n ABC Direct Marketingo S1004r Whites Mediumt Level Technologies, Inc.u CV104 Large Box 1E 1.5495F 5/1/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92161Q Solde Updatedf -1.5495l 1.5495m 1993n ABC Direct Marketingo S1004r Whites Medium Level Technologies, Inc.u CV104 Solar WidgetE 1.2975F 5/1/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 92161Q Solde Updatedf -2.595l 2.595m 1993n ABC Direct Marketingo S1004r Whites Mediumt Level Technologies, Inc.u CV104 Plastic Coated WidgetE .0405F 9/28/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92186Q -10U SeptemberV Solde Updatedf -.405l .405m 1993n XYZ Companyo S1002r Whites Medium May Department Storesu CV105 Large Box 1E 1.5495F 9/28/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92186Q -2U SeptemberV Solde Updatedf -3.099l 3.099m 1993n XYZ Companyo S1002r Whites Mediumt May Department Storesu CV105 Solar WidgetE 1.2975F 9/28/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 92186Q -4U SeptemberV Solde Updatedf -5.19l 5.19m 1993n XYZ Companyo S1002r Whites Mediumt May Department Storesu CV105 Plastic Coated WidgetE .0405F 6/11/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Solde Updatedf -.2025l .2025m 1993n XYZ Companyo S1006r Whites Mediumt Snider Distributorsu CV107 Large Box 1E 1.5495F 6/11/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Solde Updatedf -1.5495l 1.5495m 1993n XYZ Companyo S1006r Whites Mediumt Snider Distributorsu CV107 Solar WidgetE 1.2975F 6/11/93 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93119Q JuneV Solde Updatedf -2.595l 2.595m 1993n XYZ Companyo S1006r Whites Mediumt Snider Distributorsu CV107 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93120U JanuaryV Solde Updatedm 1993n ABC Direct Marketingo S1007t Snider Distributorsu CV107 Plastic Coated WidgetE .0405F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Solde Updatedf -.2025l .2025m 1993n ABC Direct Marketingo S1008r Whites Mediumt Snider Distributorsu CV107 Large Box 1E 1.5495F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Solde Updatedf -1.5495l 1.5495m 1993n ABC Direct Marketingo S1008r Whites Mediumt Snider Distributorsu CV107 Solar WidgetE 1.2975F 1/7/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93122Q JanuaryV Solde Updatedf -2.595l 2.595m ABC Direct Marketingo S1008r Whites Mediumt Snider Distributorsu CV107 Plastic Coated WidgetE .0405F 1/17/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93128Q JanuaryV Solde Updatedf -.405l .405m 1993n XYZ Companyo S1009r Whites Mediumt Richard Martinu CV106 Large Box 1E 1.5495F 1/17/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93128Q JanuaryV Solde Updatedf -3.099l 3.099m 1993n XYZ Companyo S1009 Whites Mediumt Richard Martinu CV106 Solar WidgetE 1.2975F 1/17/93G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93128Q JanuaryV Solde Updatedf -5.19l 5.19m 1993n XYZ Companyo S1009r Whites Mediumt Richard Martinu CV106 Plastic Coated WidgetE .0405F 1/16/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93129Q JanuaryV Solde Updatedf -.81l 1993n XYZ Companyo S1010r Whites Mediumt Snider Distributorsu CV107 Large Box 1E 1.5495F 1/16/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93129Q JanuaryV Solde Updatedf -6.198l 6.198m 1993n XYZ Companyo S1010r Whites Mediumt Snider Distributorsu CV107 Solar WidgetE 1.2975F 1/16/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93129Q JanuaryV Solde Updatedf -10.38l 10.38m 1993n XYZ Companyo S1010r Whites Mediumt Snider Distributorsu CV107 Plastic Coated WidgetE .0405 2/21/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93159Q FebruaryV Solde Updatedf -.6075l .6075m 1993n XYZ Companyo S1011r Whites Mediumt Snider Distributorsu CV107 Large Box 1E 1.5495F 2/21/93G 11/19/93H Dennis E. Browne, Sales ManagerI E1003J 93159Q FebruaryV Solde Updatedf -4.6485l 4.6485m 1993n XYZ Companyo S1011r Whites Mediumt Snider Distributorsu CV107 Solar WidgetE 1.2975F 2/21/93G 11/19/93 Dennis E. Browne, Sales ManagerI E1003J 93159Q FebruaryV Solde Updatedf -7.785l 7.785m 1993n XYZ Companyo S1011r Whites Mediumt Snider Distributorsu CV107 046D Tough PakE 4.347G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93118Z Plastic Coated Widget Large Box 1 Solar Widget] .0405 1.5495 1.2975` Returnedd 9/6/93e Updatedf 35.99k 35.99l ABC Direct Marketingo S1005r Whites Medium CV103u Last Resort Lodging Solar WidgetE 3.19G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93118Z Returnedd 9/6/93e Updatedf ABC Direct Marketingo S1005r Metallics Mediumt CV103u Last Resort Lodging Plastic Coated WidgetE .0405G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93118` Returnedd 9/6/93e Updatedh .2025l ABC Direct Marketingo S1005r Whites Mediumt CV103u Last Resort Lodging Large Box 1 1.5495G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93118` Returnedd 9/6/93e Updatedh 1.5495l ABC Direct Marketingo S1005r Whites Mediumt CV103u Last Resort Lodging Solar WidgetE 1.2975G 11/19/93H"Julie R. Smith, Customer Serv. MgrI E1004J 93118` Returnedd 9/6/93e Updatedh 2.595l ABC Direct Marketingo S1005r Whites Mediumt CV103u Last Resort Lodging Bought Go To HomeBase Go To Reports Layout Print Item Sold Report $Print Item Sold Report - By Customer !Print Item Sold Report (By Month) (Print Item Sold Report (By Month & Item) #Print Item Sold Report (By Quarter) *Print Item Sold Report (By Quarter & Item) .Print Item Sold Report (By Salesperson & Item) &Print Item Purchased Report (By Month) -Print Item Purchased Report (By Month & Item) (Print Item Purchased Report (By Quarter) /Print Item Purchased Report (By Quarter & Item) $-----------Utility Scripts---------- )Find "" in Item Number & Delete Found Set "%Find "0" in Qty Sold -- No Components Close Inventory Files &)-----------Bought Units Scripts---------- (&Import From PurchOrd (Bought Units #1) *)Import from CompTemp.fm (Bought Units #2) ,"Export Summaries (Bought Units #3) .'-----------Sold Units Scripts---------- 0'Import From Invoices.FM (Sold Units #1) 2'Import from CompTemp.fm (Sold Units #2) 4 Export Summaries (Sold Units #3) 6+-----------Returned Units Scripts---------- 8$Import From Invoices.FM (Returns #1) :$Import from CompTemp.fm (Returns #2) Export Summaries (Returns #3) A'Import From Invoices.FM (Sold Units #1) Invoices.FMxport CompTemp.FM Inv_Temp.FM A Export Summaries (Sold Units #3) INV_XPORT Updated SoldB Updated Go To HomeBase HomeBase.FM A(Print Item Sold Report (By Month & Item) A*Print Item Sold Report (By Quarter & Item) A.Print Item Sold Report (By Salesperson & Item) A!Print Item Sold Report (By Month) A#Print Item Sold Report (By Quarter) Go To Reports Layout A'Import from CompTemp.fm (Sold Units #2) CompTemp.FM import from comptemp.fm CompTemp.FM Updated A%Find "0" in Qty Sold -- No Components A$Import From Invoices.FM (Returns #1) Invoices.FMxport CompTemp.FMturns #1) FM (Returns #1) Inv_Temp.FM Returned Export Summaries (Returns #3) INV_XPORT Returned Updated ReturnedB Updated A$Import from CompTemp.fm (Returns #2) CompTemp.FM import from comptemp.fm CompTemp.FM Returned Updated A)Find "" in Item Number & Delete Found Set Print Item Sold Report *A-Print Item Purchased Report (By Month & Item) Bought +A/Print Item Purchased Report (By Quarter & Item) Bought .A&Print Item Purchased Report (By Month) Bought /A(Print Item Purchased Report (By Quarter) Bought 0A$-----------Utility Scripts---------- 2A&Import From PurchOrd (Bought Units #1) PurchOrd.FMxport CompTemp.FM Inv_Temp.FM Import From PurchOrd #1 Bought 3A)Import from CompTemp.fm (Bought Units #2) CompTemp.FM import from comptemp.fm CompTemp.FM Bought Updated 6A"Export Summaries (Bought Units #3) INV_XPORT BoughtB Updated ;A)-----------Bought Units Scripts---------- <A'-----------Sold Units Scripts---------- =A+-----------Returned Units Scripts---------- Close Inventory Files CompTemp.FM Inv_Temp.FM xA$Print Item Sold Report - By Customer 'LxIqDn LxIqD 1T9VqDn 1T9VqDn Helvetica Geneva Arial %%DSIDICT:_cv currentdict /bu known {bu}if userdict /_cv known not{userdict /_cv 30 dict put}if _cv begiB /bdf{bind def}bind def currentscreen/cs exch def/ca exch def/cf exch def systemdict/setcmykcolor known{/cvcmyk /setcmykcolor load def}{/cvcmyk{1 sub 4 1 roll 3{3 index add neg dup 0 lt{pop 0}if 3 1 roll}repea t setrgbcolor pop}bdf}ifelse /ss{//cf //ca //cs setscreen}bdf /stg{ss setgray}bdf /strgb{ss setrgbcolor}bdf /stcmyk{ss cvcmyk}bdf /min1{dup 0 eq{pop 1}if}bdf currentdict /bn known {bn}if 0drw2 ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" %%DSIDICT:_cv currentdict /bu known {bu}if userdict /_cv known not{userdict /_cv 30 dict put}if _cv begi /bdf{bind def}bind def currentscreen/cs exch def/ca exch def/cf exch def systemdict/setcmykcolor known{/cvcmyk /setcmykcolor load def}{/cvcmyk{1 sub 4 1 roll 3{3 index add neg dup 0 lt{pop 0}if 3 1 roll}repeaC t setrgbcolor pop}bdf}ifelse /ss{//cf //ca //cs setscreen}bdf /stg{ss setgray}bdf /strgb{ss setrgbcolor}bdf /stcmyk{ss cvcmyk}bdf /min1{dup 0 eq{pop 1}if}bdf currentdict /bn known {bn}if 1 _cv begin stg end 0drw2 1 _cv begin stg end ~ffff ffffff ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" %%DSIDICT:_cv currentdict /bu known {bu}if userdict /_cv known not{userdict /_cv 30 dict put}if _cv B begin /bdf{bind def}bind def currentscreen/cs exch def/ca exch def/cf exch def systemdict/setcmykcolor known{/cvcmyk /setcmykcolor load def}{/cvcmyk{1 sub 4 1 roll 3{3 index add neg dup 0 lt{pop 0}if 3 1 roll}r epeat setrgbcolor pop}bdf}ifelse /ss{//cf //ca //cs setscreen}bdf /stg{ss setgray}bdf /strgb{ss setrgbcolor}bdf /stcmyk{ss cvcmyk}bdf /min1{dup 0 eq{pop 1}if}bdf currentdict /bn known {bn}if T:P0 (JP*d @(0 )0.8125 0.8125 0.8125 _cv begin strgb end `drw2 0 _cv begin stg end )0.8125 0.8125 0.8125 _cv begin strgb end 0 _cv begin stg end """""" """""" )0.1333 0.1333 0.1333 _cv begin strgb end `drw2 """""""""""" )0.1333 0.1333 0.1333 _cv begin strgb end )0.1333 0.1333 0.1333 _cv begin strgb end )0.1333 0.1333 0.1333 _cv begin strgb end DDDDDD DDDDDD )0.2667 0.2667 0.2667 _cv begin strgb end `drw2 DDDDDDDDDDDD )0.2667 0.2667 0.2667 _cv begin strgb end )0.2667 0.266R 7 0.2667 _cv begin strgb end )0.2667 0.2667 0.2667 _cv begin strgb end """""" )0.5083 0.5083 0.5083 _cv begin strgb end `drw2 """""" )0.1333 0.1333 0.1333T _cv begin strgb end )0.5083 0.5083 0.5083 _cv begin strgb end )0.1333 0.1333 0.1333 _cv begin strgb end )0.6416 0.6416 0.6416 _cv begin strgb end `drw2 0 _cv begin stg end )0.6416 0.6416 0.6416 _cv begin strgb end 0 _cv begin stg end DDDDDD )0.1333 0.1333 0.1333 _cv begin strgb end `drw2 DDDDDD 0 _cv begin stg end )0.1333 0.1333 0.1333 _cv begin strgb end 0 _cv begin stg end )0.6875 0.6875 0.6875 _cv begin strgb end `drw2 0 _cv begin stg end )0.6875 0.6875 0.6875 _cv begin strgb end 0 _cv begin stg end Xdrw2 currentpoint currentpoint /DamPage MkerSv save def _cv begin 2 index sub exch 3 index sub 7 div min1 exch 7 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 536 sub exch 310 sub translate end 1 _cv begin stg end pnewp^ 536.7500 310.5000 moveto 536.7500 310.5000 542.7500 316.5000 542.7500 316.5000 curveto closepath eofill DamPageMkerSv restore currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 index sub exch 3 index sub 7 div min1 exch 7 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 536 sub exch 310 sub translate end 1 _cv b` egin stg end newpath 536.7500 310.5000 moveto 536.7500 310.5000 542.7500 316.5000 542.7500 316.5000 curveto 0.7500 0.7500 scale 1 setlinewidth stroke DamPageMkerSv restore Xdrw2 currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 index sub exch 3 index sub 7 div min1 exch 7 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 497 sub exch 297 sub translate end 1 _cv begin stg end pnewpath 497.5000 297.5000 moveto 497.5000 297.5000 503.5000 303.5000 503.5000 303.5000 curveto closepath eofill DamPageMkerSv restore currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 index sub exch 3 index sub 7 div min1 exch 7 div min1 2 copy scale 3 -1 roll e xch div 3 1 roll div 497 sub exch 297 sub translate end 1 _cv begin stg end newpath 497.5000 297.5000 moveto 497.5000 297.5000 503.5000 303.5000 503.5000 303.5000 curveto 0.7500 0.7500 scale 1f setlinewidth stroke DamPageMkerSv restore Xdrw2 currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 index sub exch 3 index sub 7h div min1 exch 7 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 356 sub exch 297 sub translate end 1 _cv begin stg end pnewpath 356.7500 297.2500 moveto 356.7500 297.2500 362.7500 303.25 00 362.7500 303.2500 curveto closepath eofill DamPageMkerSv restore currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 indej x sub exch 3 index sub 7 div min1 exch 7 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 356 sub exch 297 sub translate end 1 _cv begin stg end newpath 356.7500 297.2500 moveto 356.7500 297.2500 362.7500 303.2500 362.7500 303.2500 curveto 0.7500 0.7500 scale 1 setlinewidth stroke DamPageMkerSv restore Xdrw2 currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 index sub exch 3 index sub 7 div min1 exch 6 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 356 sub exch 240 sub translate end 1 _cv begin stg endn \newpath 356.7500 240 moveto 356.7500 240 362.7500 246 362.7500 246 curveto closepath eofill DamPageMkerSv restore currentpoint currentpoint /DamPageMkerSv save def _cv begin 2 index sub exch 3 index sub 7 div min1 exch 6 div min1 2 copy scale 3 -1 roll exch div 3 1 roll div 356 sub exch 240 sub translate end 1 _cv begin stgp unewpath 356.7500 240 moveto 356.7500 240 362.7500 246 362.7500 246 curveto 0.7500 0.7500 scale 1 setlinewidth stroke DamPageMkerSv restore 0drw2 Main Dictionary User Dictionary CURRENT INVENTORY